An Observation on Database Buffering Performance Metrics
نویسنده
چکیده
Database buffering normally assumes that a proper measure of performance is the number of pages transferred. This paper justifies that the number of I/O’s is the proper unit of measure. From this we derive a buffering policy that improves over known buffering policies for nested loop joins, we derive some buffering policies for hashing joins, and we make an observation about selections and query optimization.
منابع مشابه
HUMAN METRICS AFFECTING SUPPLY CHAIN PERFORMANCE: AN EMPIRICAL STUDY OF INDIAN MANUFACTURING ORGANIZATIONS
The manufacturing organizations today are having a competition of supply chain versus supply chain. Existing research work fails to relate human metrics with supply chain performance. The authors intend to empirically assess the effects of human metrics on supply chain performance in the context of Indian manufacturing organizations. A rigorous literature review has identified 12 variables. The...
متن کاملSustainable Supplier Selection by a New Hybrid Support Vector-model based on the Cuckoo Optimization Algorithm
For assessing and selecting sustainable suppliers, this study considers a triple-bottom-line approach, including profit, people and planet, and regards business operations, environmental effects along with social responsibilities of the suppliers. Diverse metrics are acquainted with measure execution in these three issues. This study builds up a new hybrid intelligent model, namely COA-LS-SVM, ...
متن کاملAcute effect of calcium lactate supplementation intake on the performance and buffering capacity of elite amateur boxing athletes
This study aimed to assess the effects of acute calcium lactate supplementation intake on the performance and buffering capacity of elite amateur boxing athletes. 8 elite amateur boxers (180±4.33 cm, 24.12±3.68 years, Weight categories: -75, -64, -69, +81) were assigned to acutely receive calcium lactate (0.5 g, 80 mg calcium lactate/kg body weight) and placebo in a double-blind crossover desig...
متن کاملAn Improvement in WRP Block Replacement Policy with Reviewing and Solving its Problems
One of the most important items for better file system performance is efficient buffering of disk blocks in main memory. Efficient buffering helps to reduce the widespeed gap between main memory and hard disks. In this buffering system, the block replacement policy is one of the most important design decisions that determines which disk block should be replaced when the buffer is full. To o...
متن کاملAn Improvement in WRP Block Replacement Policy with Reviewing and Solving its Problems
One of the most important items for better file system performance is efficient buffering of disk blocks in main memory. Efficient buffering helps to reduce the widespeed gap between main memory and hard disks. In this buffering system, the block replacement policy is one of the most important design decisions that determines which disk block should be replaced when the buffer is full. To o...
متن کامل